Creating a CSV Report
In this example, we will use the Employees table within the sample database to create a CSV report. The table contains the following fields which are all used in the Report query.
| Field name | Description |
|---|---|
| emp_id | Employee Number |
| last_name | Employee Last Name |
| first_name | Employee First Name |
| hire_date | Hire Date |
| salary | Salary |
| dept_id | Department ID |
| location_id | Location ID (a department can exist in several locations) |
| Street_Line1 | 1st line of address |
| Street_Line2 | 2nd line of address |
| Street_Line3 | 3rd line of address |
| city | City |
| state | State |
| zip | Zip Code |